﻿CREATE TABLE [dbo].[Product] (
    [ID_Product]               INT          IDENTITY (1, 1) NOT NULL,
    [Name]                     VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
    [Id_ProductType]           INT          NOT NULL,
    [Id_UnitMeasurement]       INT          NOT NULL,
    [NetWeight]                DECIMAL (18) NULL,
    [GrossWeight]              DECIMAL (18) NULL,
    [TechnicalCharacteristic1] VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [TechnicalCharacteristic2] VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [TechnicalCharacteristic3] VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [TechnicalCharacteristic4] VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [TechnicalCharacteristic5] VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [TechnicalCharacteristic6] VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [TechnicalCharacteristic7] VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [TechnicalCharacteristic8] VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [TechnicalCharacteristic9] VARCHAR (50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Id_Company]               INT          NULL
);

